package com.cssl.dao;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.cssl.pojo.AttStaffPerformance;
import com.cssl.pojo.SysStaff;
import org.apache.ibatis.annotations.Param;

import javax.management.Query;
import java.util.List;
import java.util.Map;

/**
* @author YY
* @description 针对表【sys_staff(员工表)】的数据库操作Mapper
* @createDate 2023-05-09 11:54:15
* @Entity com.model.pojo.SysStaff
*/
public interface SysStaffMapper extends BaseMapper<SysStaff> {

    //登录
    public SysStaff selectid(@Param("code") String code,@Param("pwd") String pwd);

    public SysStaff selectid2(@Param("id") String id);

    public List<SysStaff> select(@Param("ew")QueryWrapper<SysStaff> ew);

    //选择员工查询
    public IPage<SysStaff> seleo(IPage<SysStaff> page, @Param("ew")QueryWrapper<SysStaff> ew);

    //用户信息查询分页
    public IPage<SysStaff> selecty(IPage<SysStaff> page,@Param("ew") QueryWrapper<SysStaff> ew);


    //导出查询
    public List<SysStaff> queryUserInfo();


    int querySum();

    int querySy();

    int queryZc();

    int queryAgeBoy();
    int queryAgeBoy2();
    int queryAgeBoy3();
    int queryAgeBoy4();
    int queryAgeBoy5();

    int queryAgeGirl();
    int queryAgeGirl2();
    int queryAgeGirl3();
    int queryAgeGirl4();
    int queryAgeGirl5();

    //导入到出的批量插入
    public int addUserInfo(List<SysStaff> list);


    //入职表查询
    public List<SysStaff> Entry(@Param("create_time") String create_time);


    //解聘的时候修改
    public int supdate(int id);




}




